In tune mode, a database administrator already knows that a part of the database physical design should be fixed, but he wants database engine tuning advisor to recommend the best physical design structures for the rest of the configuration 在优化模式中,数据库管理员已经知道应该对数据库物理设计的一部分进行修改,但是希望数据库引擎优化顾问能够为其余配置提供最佳物理设计结构方面的建议。
The design of the database system can be done by the following steps according to the normalization requirement : plan, requirements analysis, conceptual structure design, logical structure design, database physical design, database actualization and database running and maintenance 按照规范化设计要求,数据库系统设计按以下几步进行:规划、需求分析、概念结构设计、逻辑结构设计、数据库物理设计、数据库实现及数据库运行和维护。
The data and the function requirements for this database system are deducted firstly by the analyzing of the data flow fig and the compiling of the data dictionary . then, the local e-r fig and the whole e-r fig are obtained by concept structure design . the database physical design is finally completed by sql server 2000 and the whole structure of the database is built 首先通过分析系统数据流图,编写数据字典,得出数据库系统的数据和功能需求;然后经过概念结构设计得到数据库局部e?r图和全局e-r图,经过逻辑结构设计将e?r图转换成关系数据模型;最后采用sqlserver2000作为工具完成了数据库的物理设计并建立了数据库的全部结构。